package com.jiangsong.mapper;

import com.jiangsong.entity.FeeRate;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @author jiangsong
 * @date 2021/4/15
 **/

@Mapper
public interface FeeRateMapper {


    @Select("select * from fee_rate where acc_no = #{accNo}")
    List<FeeRate> getFeeRatesByAccNo(String accNo);

    /**
     * 批量插入数据
     */
    @Insert("insert into fee_rate (acc_no, proj_no, proj_desc, amt, rate, charge_date) values (#{feeRate.accNo},#{feeRate.projNo},#{feeRate.projDesc},#{feeRate.amt},#{feeRate.rate},#{feeRate.chargeDate})")
    int insertOne(@Param("feeRate") FeeRate feeRate);

}
